Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 include("connect.php");
4 error_reporting(0);
5 ?>
6 <?php
7 SESSION_START();
8 ?>
9 <!DOCTYPE html>
10 <html>
11
12 <head>
13 <meta charset="utf-8">
14 <meta name="viewport" content="width=device-width, initial-scale=1.0">
15 <title>school management system</title>
16 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
17 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
18 <link href="assets/css/loader.css" rel="stylesheet" />
19 <script src="assets/js/canvasjs.min.js"></script>
20 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
21 <script src="assets/js/jquery-3.2.1.js"></script>
22
23 <!--***************the year search text box*************************************************-->
24 <script>
25 function myFunction() {
26 // Declare variables
27 var input, filter, table, tr, td, i;
28 input = document.getElementById("myInput");
29 filter = input.value.toUpperCase();
30 table = document.getElementById("myTable");
31 tr = table.getElementsByTagName("tr");
32
33 // Loop through all table rows, and hide those who don't match the search query
34 for (i = 0; i < tr.length; i++) {
35 td = tr[i].getElementsByTagName("td")[1];
36 if (td) {
37 if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
38 tr[i].style.display = "";
39 } else {
40 tr[i].style.display = "none";
41 }
42 }
43 }
44 }
45 </script>
46 <!--***************the year search text box*************************************************-->
47 <script>
48 function myFunction2() {
49 // Declare variables
50 var input, filter, table, tr, td, i;
51 input = document.getElementById("myInput2");
52 filter = input.value.toUpperCase();
53 table = document.getElementById("myTable");
54 tr = table.getElementsByTagName("tr");
55
56 // Loop through all table rows, and hide those who don't match the search query
57 for (i = 0; i < tr.length; i++) {
58 td = tr[i].getElementsByTagName("td")[2];
59 if (td) {
60 if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
61 tr[i].style.display = "";
62 } else {
63 tr[i].style.display = "none";
64 }
65 }
66 }
67 }
68 </script>
69
70
71 </head>
72
73 <body >
74 <!--end of heading section-->
75 <ul class="nav navbar-right top-nav">
76 <div class="dropdown">
77 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
78 <?php
79 //Check to see if the user is logged in.if not redirect user to the loging page.
80
81 if(isset($_SESSION['fname']))
82 {
83 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
84 }else{
85 echo "<script type='text/javascript'>
86 alert( 'You must Log in to use the system');
87 </script>";
88 echo "<script>
89 window.location = 'index.php'
90 </script>";
91 }
92 ?>
93 <span class="caret"></span></button>
94 <ul class="dropdown-menu">
95 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
96 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
97 <li class="divider"></li>
98 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
99 </ul>
100 </div>
101 </ul>
102 <!--************************************************-->
103 <div style="
104 font-family:Nyala, Arial;
105 text-align: left;
106 background-color: #526F35;
107 padding: 20px;
108 color:white;
109 width: 100%;
110 height: 150px;">
111 <!--This codes to load the image loader-->
112 <div id="loading">
113 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
114 </div>
115 <!--this is the heading section-->
116 <h2>
117 <?php
118 $sql="SELECT * FROM companyinfo";
119 $result=mysqli_query($db,$sql) or die("error getting data");
120 $num_rows=mysqli_num_rows($result);
121 while($row=mysqli_fetch_array($result))
122 {
123 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
124 $cname = $row['cname'];
125 $cemail = $row['cemail'];
126 $ccontact = $row['ccontact'];
127 $clocation = $row['clocation'];
128 }?>
129 <?php
130 echo $cname;
131 ?>
132
133 <div style="float:right; font-size:20px;text-align:right;">
134
135 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
136 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
137 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
138
139 </div>
140 </h2>
141 </div>
142 <!--end of heading section-->
143
144 <div>
145 <ul class="nav nav-tabs">
146 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
147 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
148 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
149 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
150 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
151 <li class="active"><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
152 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
153 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
154 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
155 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
156
157 </ul>
158 <div class="tab-content">
159 <div class="tab-pane active" role="tabpanel" id="tab-1">
160
161 <p>
162 <div class="table-responsive" >
163 <!--****************************************************************************-->
164 <div class="container" style="width:100%">
165
166 <ul class="nav nav-tabs">
167 <li ><a href="markstep1.php">Choose Class <img src="assets/img/new.png"> </a></li>
168
169 <li><a href="markstep3.php">Enter Marks<img src="assets/img/view2.png"></a></li>
170
171
172
173
174 <li><a href="markstep7.php">Print Transcript<img src="assets/img/print.png"> </a></li>
175 </ul>
176 <br>
177
178 </div>
179
180 <!--*************************************************************************************************************************-->
181 <div id="page-wrapper">
182 <div class="container-fluid">
183
184
185 <!-- Page Heading -->
186 <nav>
187
188 <center><h4><strong>Enter marks, each student at a time</strong><h4></center>
189
190
191
192 <!-- block -->
193 <div id="block_bg" class="block">
194 <div class="navbar navbar-inner block-header">
195
196 <table>
197 <tr>
198 <td><a button type='button' class="btn btn-primary" href="markstep1.php"><--</a></td>
199 <td><a button type='button' class="btn btn-primary glyphicon glyphicon-print" href="#"></a></td>
200 <td><label>Search using Admission number</label></td>
201 <td><input type="text" name="myInput" id="myInput" class="form-control"
202 placeholder="Adm no" onkeyup="myFunction()"></td>
203 <td><label>Name</label></td>
204 <td><input type="text" name="myInput2" id="myInput2" class="form-control"
205 placeholder="Name" onkeyup="myFunction2()"></td></tr></table>
206
207
208 <div class="block-content collapse in">
209 <div class="span12">
210
211 <form method="post">
212 <div class="table-responsive">
213 <table cellpadding="0" cellspacing="0" border="0" class="table" id="myTable" >
214
215 <thead>
216 <tr>
217 <th></th>
218 <th><center>Adm No.</center></th>
219 <th><center>Name</center></th>
220 <th><center>Gender</center></th>
221 <th><center>Email Address</center></th>
222 <th><center>Mobile</center></th>
223 <th><center>Address</center></th>
224 <th><center>Reg. Date</center></th>
225 <th><center>Edit</center></th>
226 <script src="assets/js/jquery.dataTables.min.js"></script>
227 <script src="assets/js/DT_bootstrap.js"></script>
228 <th></th>
229 </tr>
230 </thead>
231 <tbody>
232 <?php
233
234 $sql ="SELECT * from studentstable where course_id=6";
235 $user_query=mysqli_query($db,$sql) or die("error getting data");
236 while($row = mysqli_fetch_array($user_query)){
237 $id = $row['admission_number'];
238 ?>
239
240
241 <tr>
242 <td width="30">
243 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $id; ?>">
244 </td>
245 <td><center><?php echo $row['admission_number']; ?></center></td>
246 <td><center><?php echo $row['sirname']." ".$row['firstname']." ".$row['lastname']; ?></center></td>
247 <td><center><?php echo $row['gender']; ?></center></td>
248 <td><center><?php echo $row['email']; ?></center></td>
249 <td><center><?php echo $row['mobile']; ?></center></td>
250 <td><center><?php echo $row['address']."-".$row['zipcode']; ?></center></td>
251 <td><center><?php echo $row['reg_date']; ?></center></td>
252
253 <td>
254 <center><a href="marks_packages.php <?php echo '?id='.$id; ?>" class="btn btn-success"><i class="glyphicon glyphicon-pencil"></i>Enter Marks</a></center></td>
255 <td>
256 <center><a href="markstep7.php <?php echo '?id='.$id; ?>" class="btn btn-info"><i class="glyphicon glyphicon-print"></i>Print Transcript</a></center></td>
257
258
259 </tr>
260 <?php } ?>
261 </tbody>
262 </table>
263 </form>
264
265 </div>
266 </div>
267 </div>
268 </div>
269 <!-- /.container-fluid -->
270
271 </div>
272 <!-- /#page-wrapper -->
273 </div>
274 <!--*********************************************************************************-->
275 <div class="col-md-12" style="background-color:#526F35; bottom:0px;position:fixed;">
276 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
277 </div>
278 <script src="assets/js/jquery.min.js"></script>
279 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
280 <script src="assets/js/affix.js"></script>
281 <script src="assets/js/alert.js"></script>
282 <script src="assets/js/alert1.js"></script>
283 <script src="assets/js/bootstrap.js"></script>
284 <script src="assets/js/bootstrap.min.js"></script>
285 <script src="assets/js/bootstrap-datepicker.js"></script>
286 <script src="assets/js/bootstrap-wysihtml5.js"></script>
287 <script src="assets/js/button.js"></script>
288 <script src="assets/js/carousel.js"></script>
289 <script src="assets/js/chosen.jquery.min.js"></script>
290 <script src="assets/js/ckeditor.js"></script>
291 <script src="assets/js/collapse.js"></script>
292 <script src="assets/js/color.js"></script>
293 <script src="assets/js/dropdown.js"></script>
294 <script src="assets/js/DT_bootstrap.js"></script>
295 <script src="assets/js/dynamic.js"></script>
296 <script src="assets/js/ie-emulation-modes-warning.js"></script>
297 <script src="assets/js/jquery.dataTables.js"></script>
298 <script src="assets/js/jquery.dataTables.min.js"></script>
299 <script src="assets/js/jquery.dialog.js"></script>
300 <script src="assets/js/jquery.hoverdir.js"></script>
301 <script src="assets/js/jquery.jgrowl.js"></script>
302 <script src="assets/js/jquery.knob.js"></script>
303 <script src="assets/js/jquery.uniform.min.js"></script>
304 <script src="assets/js/jquery-1.8.3.min.js"></script>
305 <script src="assets/js/jquery-1.9.1.js"></script>
306 <script src="assets/js/jquery-1.9.1.min.js"></script>
307 <script src="assets/js/jquery-1.10.2.js"></script>
308 <script src="assets/js/jquery-1.11.0.js"></script>
309 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
310 <script src="assets/js/jquery-ui-1.10.3.js"></script>
311 <script src="assets/js/modal.js"></script>
312 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
313 <script src="assets/js/myjquery.js"></script>
314 <script src="assets/js/myjquery1.js"></script>
315 <script src="assets/js/npm.js"></script>
316 <script src="assets/js/popover.js"></script>
317 <script src="assets/js/profile.js"></script>
318 <script src="assets/js/raphael-min.js"></script>
319 <script src="assets/js/sb-admin-2.js"></script>
320 <script src="assets/js/scripts.js"></script>
321 <script src="assets/js/scrollspy.js"></script>
322 <script src="assets/js/tab.js"></script>
323 <script src="assets/js/tooltip.js"></script>
324 <script src="assets/js/transition.js"></script>
325 <script src="assets/js/wysihtml5-0.3.0.js"></script>
326 <script language="javascript" type="text/javascript">
327 $(window).load(function()
328 {
329 $('#loading').hide();
330 });
331 </script>
332 </body>
333
334 </html>
